package com.iflytek.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.iflytek.bean.StockOutOrder;
import com.iflytek.bean.StockOutOrderExample;
import com.iflytek.vo.StockOutOrderVO;

public interface StockOutOrderMapper {
    long countByExample(StockOutOrderExample example);

    int deleteByExample(StockOutOrderExample example);

    int deleteByPrimaryKey(Integer orderId);

    int insert(StockOutOrder record);

    int insertSelective(StockOutOrder record);

    List<StockOutOrder> selectByExample(StockOutOrderExample example);

    StockOutOrder selectByPrimaryKey(Integer orderId);

    int updateByExampleSelective(@Param("record") StockOutOrder record, @Param("example") StockOutOrderExample example);

    int updateByExample(@Param("record") StockOutOrder record, @Param("example") StockOutOrderExample example);

    int updateByPrimaryKeySelective(StockOutOrder record);

    int updateByPrimaryKey(StockOutOrder record);
    @Select("select * from stock_out_order s join goods g on s.goods_id=g.goods_id join  warehouse w on s.soo_warehouse_id=w.warehouse_id")
    List<StockOutOrderVO> showAll();
}